SecDefRequestGateway

V8 Message Definiton

METADATA

Attribute	Value
Topic	5120-srse-gateway
MLink Token	Internal
Product	SRTrade
accessType	SELECT,INSERT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
secRequestID	BIGINT	PRI	0
secDefType	enum - SecDefType		'None'
accnt	VARCHAR(16)		''	routing code of exchange session handling product def request
clientFirm	VARCHAR(16)		''
altRequestId	VARCHAR(24)		''	Alternate request ID Can by used by client for tracking
secKey1_at	enum - AssetType		'None'	Symbol for leg 1 Must be a valid symbol
secKey1_ts	enum - TickerSrc		'None'	Symbol for leg 1 Must be a valid symbol
secKey1_tk	VARCHAR(12)		''	Symbol for leg 1 Must be a valid symbol
secKey1_yr	SMALLINT UNSIGNED		1900	Symbol for leg 1 Must be a valid symbol
secKey1_mn	TINYINT UNSIGNED		0	Symbol for leg 1 Must be a valid symbol
secKey1_dy	TINYINT UNSIGNED		0	Symbol for leg 1 Must be a valid symbol
secKey1_xx	DOUBLE		0	Symbol for leg 1 Must be a valid symbol
secKey1_cp	enum - CallPut		'Call'	Symbol for leg 1 Must be a valid symbol
secType1	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio1	SMALLINT UNSIGNED		0	Ratio for leg 1 Must be greater than zero
side1	enum - BuySell		'Buy'	Order side for leg 1
refPrc1	DOUBLE		0	Reference price for leg 1
refDelta1	FLOAT		0	Reference delta for leg 1
secKey2_at	enum - AssetType		'None'	Symbol for leg 2 Must be a valid symbol
secKey2_ts	enum - TickerSrc		'None'	Symbol for leg 2 Must be a valid symbol
secKey2_tk	VARCHAR(12)		''	Symbol for leg 2 Must be a valid symbol
secKey2_yr	SMALLINT UNSIGNED		1900	Symbol for leg 2 Must be a valid symbol
secKey2_mn	TINYINT UNSIGNED		0	Symbol for leg 2 Must be a valid symbol
secKey2_dy	TINYINT UNSIGNED		0	Symbol for leg 2 Must be a valid symbol
secKey2_xx	DOUBLE		0	Symbol for leg 2 Must be a valid symbol
secKey2_cp	enum - CallPut		'Call'	Symbol for leg 2 Must be a valid symbol
secType2	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio2	SMALLINT UNSIGNED		0	Ratio for leg 2 Must be greater than zero
side2	enum - BuySell		'Buy'	Order side for leg 2
refPrc2	DOUBLE		0	Reference price for leg 2
refDelta2	FLOAT		0	Reference delta for leg 2
secKey3_at	enum - AssetType		'None'	Symbol for leg 3 Must be a valid symbol
secKey3_ts	enum - TickerSrc		'None'	Symbol for leg 3 Must be a valid symbol
secKey3_tk	VARCHAR(12)		''	Symbol for leg 3 Must be a valid symbol
secKey3_yr	SMALLINT UNSIGNED		1900	Symbol for leg 3 Must be a valid symbol
secKey3_mn	TINYINT UNSIGNED		0	Symbol for leg 3 Must be a valid symbol
secKey3_dy	TINYINT UNSIGNED		0	Symbol for leg 3 Must be a valid symbol
secKey3_xx	DOUBLE		0	Symbol for leg 3 Must be a valid symbol
secKey3_cp	enum - CallPut		'Call'	Symbol for leg 3 Must be a valid symbol
secType3	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio3	SMALLINT UNSIGNED		0	Ratio for leg 3 Must be greater than zero
side3	enum - BuySell		'Buy'	Order side for leg 3
refPrc3	DOUBLE		0	Reference price for leg 3
refDelta3	FLOAT		0	Reference delta for leg 3
secKey4_at	enum - AssetType		'None'	Symbol for leg 4 Must be a valid symbol
secKey4_ts	enum - TickerSrc		'None'	Symbol for leg 4 Must be a valid symbol
secKey4_tk	VARCHAR(12)		''	Symbol for leg 4 Must be a valid symbol
secKey4_yr	SMALLINT UNSIGNED		1900	Symbol for leg 4 Must be a valid symbol
secKey4_mn	TINYINT UNSIGNED		0	Symbol for leg 4 Must be a valid symbol
secKey4_dy	TINYINT UNSIGNED		0	Symbol for leg 4 Must be a valid symbol
secKey4_xx	DOUBLE		0	Symbol for leg 4 Must be a valid symbol
secKey4_cp	enum - CallPut		'Call'	Symbol for leg 4 Must be a valid symbol
secType4	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio4	SMALLINT UNSIGNED		0	Ratio for leg 4 Must be greater than zero
side4	enum - BuySell		'Buy'	Order side for leg 4
refPrc4	DOUBLE		0	Reference price for leg 4
refDelta4	FLOAT		0	Reference delta for leg 4
secKey5_at	enum - AssetType		'None'	Symbol for leg 5 Must be a valid symbol
secKey5_ts	enum - TickerSrc		'None'	Symbol for leg 5 Must be a valid symbol
secKey5_tk	VARCHAR(12)		''	Symbol for leg 5 Must be a valid symbol
secKey5_yr	SMALLINT UNSIGNED		1900	Symbol for leg 5 Must be a valid symbol
secKey5_mn	TINYINT UNSIGNED		0	Symbol for leg 5 Must be a valid symbol
secKey5_dy	TINYINT UNSIGNED		0	Symbol for leg 5 Must be a valid symbol
secKey5_xx	DOUBLE		0	Symbol for leg 5 Must be a valid symbol
secKey5_cp	enum - CallPut		'Call'	Symbol for leg 5 Must be a valid symbol
secType5	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio5	SMALLINT UNSIGNED		0	Ratio for leg 5 Must be greater than zero
side5	enum - BuySell		'Buy'	Order side for leg 5
refPrc5	DOUBLE		0	Reference price for leg 5
refDelta5	FLOAT		0	Reference delta for leg 5
secKey6_at	enum - AssetType		'None'	Symbol for leg 6 Must be a valid symbol
secKey6_ts	enum - TickerSrc		'None'	Symbol for leg 6 Must be a valid symbol
secKey6_tk	VARCHAR(12)		''	Symbol for leg 6 Must be a valid symbol
secKey6_yr	SMALLINT UNSIGNED		1900	Symbol for leg 6 Must be a valid symbol
secKey6_mn	TINYINT UNSIGNED		0	Symbol for leg 6 Must be a valid symbol
secKey6_dy	TINYINT UNSIGNED		0	Symbol for leg 6 Must be a valid symbol
secKey6_xx	DOUBLE		0	Symbol for leg 6 Must be a valid symbol
secKey6_cp	enum - CallPut		'Call'	Symbol for leg 6 Must be a valid symbol
secType6	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio6	SMALLINT UNSIGNED		0	Ratio for leg 6 Must be greater than zero
side6	enum - BuySell		'Buy'	Order side for leg 6
refPrc6	DOUBLE		0	Reference price for leg 6
refDelta6	FLOAT		0	Reference delta for leg 6
secKey7_at	enum - AssetType		'None'	Symbol for leg 7 Must be a valid symbol
secKey7_ts	enum - TickerSrc		'None'	Symbol for leg 7 Must be a valid symbol
secKey7_tk	VARCHAR(12)		''	Symbol for leg 7 Must be a valid symbol
secKey7_yr	SMALLINT UNSIGNED		1900	Symbol for leg 7 Must be a valid symbol
secKey7_mn	TINYINT UNSIGNED		0	Symbol for leg 7 Must be a valid symbol
secKey7_dy	TINYINT UNSIGNED		0	Symbol for leg 7 Must be a valid symbol
secKey7_xx	DOUBLE		0	Symbol for leg 7 Must be a valid symbol
secKey7_cp	enum - CallPut		'Call'	Symbol for leg 7 Must be a valid symbol
secType7	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio7	SMALLINT UNSIGNED		0	Ratio for leg 7 Must be greater than zero
side7	enum - BuySell		'Buy'	Order side for leg 7
refPrc7	DOUBLE		0	Reference price for leg 7
refDelta7	FLOAT		0	Reference delta for leg 7
secKey8_at	enum - AssetType		'None'	Symbol for leg 8 Must be a valid symbol
secKey8_ts	enum - TickerSrc		'None'	Symbol for leg 8 Must be a valid symbol
secKey8_tk	VARCHAR(12)		''	Symbol for leg 8 Must be a valid symbol
secKey8_yr	SMALLINT UNSIGNED		1900	Symbol for leg 8 Must be a valid symbol
secKey8_mn	TINYINT UNSIGNED		0	Symbol for leg 8 Must be a valid symbol
secKey8_dy	TINYINT UNSIGNED		0	Symbol for leg 8 Must be a valid symbol
secKey8_xx	DOUBLE		0	Symbol for leg 8 Must be a valid symbol
secKey8_cp	enum - CallPut		'Call'	Symbol for leg 8 Must be a valid symbol
secType8	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio8	SMALLINT UNSIGNED		0	Ratio for leg 8 Must be greater than zero
side8	enum - BuySell		'Buy'	Order side for leg 8
refPrc8	DOUBLE		0	Reference price for leg 8
refDelta8	FLOAT		0	Reference delta for leg 8
secKey9_at	enum - AssetType		'None'	Symbol for leg 9 Must be a valid symbol
secKey9_ts	enum - TickerSrc		'None'	Symbol for leg 9 Must be a valid symbol
secKey9_tk	VARCHAR(12)		''	Symbol for leg 9 Must be a valid symbol
secKey9_yr	SMALLINT UNSIGNED		1900	Symbol for leg 9 Must be a valid symbol
secKey9_mn	TINYINT UNSIGNED		0	Symbol for leg 9 Must be a valid symbol
secKey9_dy	TINYINT UNSIGNED		0	Symbol for leg 9 Must be a valid symbol
secKey9_xx	DOUBLE		0	Symbol for leg 9 Must be a valid symbol
secKey9_cp	enum - CallPut		'Call'	Symbol for leg 9 Must be a valid symbol
secType9	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio9	SMALLINT UNSIGNED		0	Ratio for leg 9 Must be greater than zero
side9	enum - BuySell		'Buy'	Order side for leg 9
refPrc9	DOUBLE		0	Reference price for leg 9
refDelta9	FLOAT		0	Reference delta for leg 9
secKey10_at	enum - AssetType		'None'	Symbol for leg 10 Must be a valid symbol
secKey10_ts	enum - TickerSrc		'None'	Symbol for leg 10 Must be a valid symbol
secKey10_tk	VARCHAR(12)		''	Symbol for leg 10 Must be a valid symbol
secKey10_yr	SMALLINT UNSIGNED		1900	Symbol for leg 10 Must be a valid symbol
secKey10_mn	TINYINT UNSIGNED		0	Symbol for leg 10 Must be a valid symbol
secKey10_dy	TINYINT UNSIGNED		0	Symbol for leg 10 Must be a valid symbol
secKey10_xx	DOUBLE		0	Symbol for leg 10 Must be a valid symbol
secKey10_cp	enum - CallPut		'Call'	Symbol for leg 10 Must be a valid symbol
secType10	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio10	SMALLINT UNSIGNED		0	Ratio for leg 10 Must be greater than zero
side10	enum - BuySell		'Buy'	Order side for leg 10
refPrc10	DOUBLE		0	Reference price for leg 10
refDelta10	FLOAT		0	Reference delta for leg 10
secKey11_at	enum - AssetType		'None'	Symbol for leg 11 Must be a valid symbol
secKey11_ts	enum - TickerSrc		'None'	Symbol for leg 11 Must be a valid symbol
secKey11_tk	VARCHAR(12)		''	Symbol for leg 11 Must be a valid symbol
secKey11_yr	SMALLINT UNSIGNED		1900	Symbol for leg 11 Must be a valid symbol
secKey11_mn	TINYINT UNSIGNED		0	Symbol for leg 11 Must be a valid symbol
secKey11_dy	TINYINT UNSIGNED		0	Symbol for leg 11 Must be a valid symbol
secKey11_xx	DOUBLE		0	Symbol for leg 11 Must be a valid symbol
secKey11_cp	enum - CallPut		'Call'	Symbol for leg 11 Must be a valid symbol
secType11	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio11	SMALLINT UNSIGNED		0	Ratio for leg 11 Must be greater than zero
side11	enum - BuySell		'Buy'	Order side for leg 11
refPrc11	DOUBLE		0	Reference price for leg 11
refDelta11	FLOAT		0	Reference delta for leg 11
secKey12_at	enum - AssetType		'None'	Symbol for leg 12 Must be a valid symbol
secKey12_ts	enum - TickerSrc		'None'	Symbol for leg 12 Must be a valid symbol
secKey12_tk	VARCHAR(12)		''	Symbol for leg 12 Must be a valid symbol
secKey12_yr	SMALLINT UNSIGNED		1900	Symbol for leg 12 Must be a valid symbol
secKey12_mn	TINYINT UNSIGNED		0	Symbol for leg 12 Must be a valid symbol
secKey12_dy	TINYINT UNSIGNED		0	Symbol for leg 12 Must be a valid symbol
secKey12_xx	DOUBLE		0	Symbol for leg 12 Must be a valid symbol
secKey12_cp	enum - CallPut		'Call'	Symbol for leg 12 Must be a valid symbol
secType12	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio12	SMALLINT UNSIGNED		0	Ratio for leg 12 Must be greater than zero
side12	enum - BuySell		'Buy'	Order side for leg 12
refPrc12	DOUBLE		0	Reference price for leg 12
refDelta12	FLOAT		0	Reference delta for leg 12
secKey13_at	enum - AssetType		'None'	Symbol for leg 13 Must be a valid symbol
secKey13_ts	enum - TickerSrc		'None'	Symbol for leg 13 Must be a valid symbol
secKey13_tk	VARCHAR(12)		''	Symbol for leg 13 Must be a valid symbol
secKey13_yr	SMALLINT UNSIGNED		1900	Symbol for leg 13 Must be a valid symbol
secKey13_mn	TINYINT UNSIGNED		0	Symbol for leg 13 Must be a valid symbol
secKey13_dy	TINYINT UNSIGNED		0	Symbol for leg 13 Must be a valid symbol
secKey13_xx	DOUBLE		0	Symbol for leg 13 Must be a valid symbol
secKey13_cp	enum - CallPut		'Call'	Symbol for leg 13 Must be a valid symbol
secType13	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio13	SMALLINT UNSIGNED		0	Ratio for leg 13 Must be greater than zero
side13	enum - BuySell		'Buy'	Order side for leg 13
refPrc13	DOUBLE		0	Reference price for leg 13
refDelta13	FLOAT		0	Reference delta for leg 13
secKey14_at	enum - AssetType		'None'	Symbol for leg 14 Must be a valid symbol
secKey14_ts	enum - TickerSrc		'None'	Symbol for leg 14 Must be a valid symbol
secKey14_tk	VARCHAR(12)		''	Symbol for leg 14 Must be a valid symbol
secKey14_yr	SMALLINT UNSIGNED		1900	Symbol for leg 14 Must be a valid symbol
secKey14_mn	TINYINT UNSIGNED		0	Symbol for leg 14 Must be a valid symbol
secKey14_dy	TINYINT UNSIGNED		0	Symbol for leg 14 Must be a valid symbol
secKey14_xx	DOUBLE		0	Symbol for leg 14 Must be a valid symbol
secKey14_cp	enum - CallPut		'Call'	Symbol for leg 14 Must be a valid symbol
secType14	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio14	SMALLINT UNSIGNED		0	Ratio for leg 14 Must be greater than zero
side14	enum - BuySell		'Buy'	Order side for leg 14
refPrc14	DOUBLE		0	Reference price for leg 14
refDelta14	FLOAT		0	Reference delta for leg 14
secKey15_at	enum - AssetType		'None'	Symbol for leg 15 Must be a valid symbol
secKey15_ts	enum - TickerSrc		'None'	Symbol for leg 15 Must be a valid symbol
secKey15_tk	VARCHAR(12)		''	Symbol for leg 15 Must be a valid symbol
secKey15_yr	SMALLINT UNSIGNED		1900	Symbol for leg 15 Must be a valid symbol
secKey15_mn	TINYINT UNSIGNED		0	Symbol for leg 15 Must be a valid symbol
secKey15_dy	TINYINT UNSIGNED		0	Symbol for leg 15 Must be a valid symbol
secKey15_xx	DOUBLE		0	Symbol for leg 15 Must be a valid symbol
secKey15_cp	enum - CallPut		'Call'	Symbol for leg 15 Must be a valid symbol
secType15	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio15	SMALLINT UNSIGNED		0	Ratio for leg 15 Must be greater than zero
side15	enum - BuySell		'Buy'	Order side for leg 15
refPrc15	DOUBLE		0	Reference price for leg 15
refDelta15	FLOAT		0	Reference delta for leg 15
secKey16_at	enum - AssetType		'None'	Symbol for leg 16 Must be a valid symbol
secKey16_ts	enum - TickerSrc		'None'	Symbol for leg 16 Must be a valid symbol
secKey16_tk	VARCHAR(12)		''	Symbol for leg 16 Must be a valid symbol
secKey16_yr	SMALLINT UNSIGNED		1900	Symbol for leg 16 Must be a valid symbol
secKey16_mn	TINYINT UNSIGNED		0	Symbol for leg 16 Must be a valid symbol
secKey16_dy	TINYINT UNSIGNED		0	Symbol for leg 16 Must be a valid symbol
secKey16_xx	DOUBLE		0	Symbol for leg 16 Must be a valid symbol
secKey16_cp	enum - CallPut		'Call'	Symbol for leg 16 Must be a valid symbol
secType16	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio16	SMALLINT UNSIGNED		0	Ratio for leg 16 Must be greater than zero
side16	enum - BuySell		'Buy'	Order side for leg 16
refPrc16	DOUBLE		0	Reference price for leg 16
refDelta16	FLOAT		0	Reference delta for leg 16
secKey17_at	enum - AssetType		'None'	Symbol for leg 17 Must be a valid symbol
secKey17_ts	enum - TickerSrc		'None'	Symbol for leg 17 Must be a valid symbol
secKey17_tk	VARCHAR(12)		''	Symbol for leg 17 Must be a valid symbol
secKey17_yr	SMALLINT UNSIGNED		1900	Symbol for leg 17 Must be a valid symbol
secKey17_mn	TINYINT UNSIGNED		0	Symbol for leg 17 Must be a valid symbol
secKey17_dy	TINYINT UNSIGNED		0	Symbol for leg 17 Must be a valid symbol
secKey17_xx	DOUBLE		0	Symbol for leg 17 Must be a valid symbol
secKey17_cp	enum - CallPut		'Call'	Symbol for leg 17 Must be a valid symbol
secType17	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio17	SMALLINT UNSIGNED		0	Ratio for leg 17 Must be greater than zero
side17	enum - BuySell		'Buy'	Order side for leg 17
refPrc17	DOUBLE		0	Reference price for leg 17
refDelta17	FLOAT		0	Reference delta for leg 17
secKey18_at	enum - AssetType		'None'	Symbol for leg 18 Must be a valid symbol
secKey18_ts	enum - TickerSrc		'None'	Symbol for leg 18 Must be a valid symbol
secKey18_tk	VARCHAR(12)		''	Symbol for leg 18 Must be a valid symbol
secKey18_yr	SMALLINT UNSIGNED		1900	Symbol for leg 18 Must be a valid symbol
secKey18_mn	TINYINT UNSIGNED		0	Symbol for leg 18 Must be a valid symbol
secKey18_dy	TINYINT UNSIGNED		0	Symbol for leg 18 Must be a valid symbol
secKey18_xx	DOUBLE		0	Symbol for leg 18 Must be a valid symbol
secKey18_cp	enum - CallPut		'Call'	Symbol for leg 18 Must be a valid symbol
secType18	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio18	SMALLINT UNSIGNED		0	Ratio for leg 18 Must be greater than zero
side18	enum - BuySell		'Buy'	Order side for leg 18
refPrc18	DOUBLE		0	Reference price for leg 18
refDelta18	FLOAT		0	Reference delta for leg 18
secKey19_at	enum - AssetType		'None'	Symbol for leg 19 Must be a valid symbol
secKey19_ts	enum - TickerSrc		'None'	Symbol for leg 19 Must be a valid symbol
secKey19_tk	VARCHAR(12)		''	Symbol for leg 19 Must be a valid symbol
secKey19_yr	SMALLINT UNSIGNED		1900	Symbol for leg 19 Must be a valid symbol
secKey19_mn	TINYINT UNSIGNED		0	Symbol for leg 19 Must be a valid symbol
secKey19_dy	TINYINT UNSIGNED		0	Symbol for leg 19 Must be a valid symbol
secKey19_xx	DOUBLE		0	Symbol for leg 19 Must be a valid symbol
secKey19_cp	enum - CallPut		'Call'	Symbol for leg 19 Must be a valid symbol
secType19	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio19	SMALLINT UNSIGNED		0	Ratio for leg 19 Must be greater than zero
side19	enum - BuySell		'Buy'	Order side for leg 19
refPrc19	DOUBLE		0	Reference price for leg 19
refDelta19	FLOAT		0	Reference delta for leg 19
secKey20_at	enum - AssetType		'None'	Symbol for leg 20 Must be a valid symbol
secKey20_ts	enum - TickerSrc		'None'	Symbol for leg 20 Must be a valid symbol
secKey20_tk	VARCHAR(12)		''	Symbol for leg 20 Must be a valid symbol
secKey20_yr	SMALLINT UNSIGNED		1900	Symbol for leg 20 Must be a valid symbol
secKey20_mn	TINYINT UNSIGNED		0	Symbol for leg 20 Must be a valid symbol
secKey20_dy	TINYINT UNSIGNED		0	Symbol for leg 20 Must be a valid symbol
secKey20_xx	DOUBLE		0	Symbol for leg 20 Must be a valid symbol
secKey20_cp	enum - CallPut		'Call'	Symbol for leg 20 Must be a valid symbol
secType20	enum - SpdrKeyType		'None'	Security Type Stock Future Option
ratio20	SMALLINT UNSIGNED		0	Ratio for leg 20 Must be greater than zero
side20	enum - BuySell		'Buy'	Order side for leg 20
refPrc20	DOUBLE		0	Reference price for leg 20
refDelta20	FLOAT		0	Reference delta for leg 20
modifiedBy	VARCHAR(24)		''	user who last modified this record
modifiedIn	enum - SysEnvironment		'None'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	timestamp of last modification

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
secRequestID	1

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRTrade`.`MsgSecDefRequestGateway`
WHERE 
    /* Replace with a BIGINT */
    `secRequestID` = 1234567890;

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRTrade`.`MsgSecDefRequestGateway`(
    /* Replace with a BIGINT */
    `secRequestID`,
    /* Replace with a ENUM('None','Covered','Combo') */
    `secDefType`,
    /* Replace with a VARCHAR(16) */
    `accnt`,
    /* Replace with a VARCHAR(16) */
    `clientFirm`,
    /* Replace with a VARCHAR(24) */
    `altRequestId`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey1_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey1_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey1_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey1_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey1_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey1_dy`,
    /* Replace with a DOUBLE */
    `secKey1_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey1_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType1`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio1`,
    /* Replace with a ENUM('Buy','Sell') */
    `side1`,
    /* Replace with a DOUBLE */
    `refPrc1`,
    /* Replace with a FLOAT */
    `refDelta1`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey2_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey2_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey2_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey2_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey2_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey2_dy`,
    /* Replace with a DOUBLE */
    `secKey2_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey2_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType2`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio2`,
    /* Replace with a ENUM('Buy','Sell') */
    `side2`,
    /* Replace with a DOUBLE */
    `refPrc2`,
    /* Replace with a FLOAT */
    `refDelta2`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey3_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey3_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey3_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey3_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey3_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey3_dy`,
    /* Replace with a DOUBLE */
    `secKey3_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey3_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType3`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio3`,
    /* Replace with a ENUM('Buy','Sell') */
    `side3`,
    /* Replace with a DOUBLE */
    `refPrc3`,
    /* Replace with a FLOAT */
    `refDelta3`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey4_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey4_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey4_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey4_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey4_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey4_dy`,
    /* Replace with a DOUBLE */
    `secKey4_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey4_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType4`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio4`,
    /* Replace with a ENUM('Buy','Sell') */
    `side4`,
    /* Replace with a DOUBLE */
    `refPrc4`,
    /* Replace with a FLOAT */
    `refDelta4`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey5_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey5_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey5_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey5_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey5_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey5_dy`,
    /* Replace with a DOUBLE */
    `secKey5_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey5_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType5`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio5`,
    /* Replace with a ENUM('Buy','Sell') */
    `side5`,
    /* Replace with a DOUBLE */
    `refPrc5`,
    /* Replace with a FLOAT */
    `refDelta5`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey6_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey6_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey6_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey6_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey6_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey6_dy`,
    /* Replace with a DOUBLE */
    `secKey6_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey6_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType6`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio6`,
    /* Replace with a ENUM('Buy','Sell') */
    `side6`,
    /* Replace with a DOUBLE */
    `refPrc6`,
    /* Replace with a FLOAT */
    `refDelta6`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey7_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey7_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey7_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey7_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey7_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey7_dy`,
    /* Replace with a DOUBLE */
    `secKey7_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey7_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType7`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio7`,
    /* Replace with a ENUM('Buy','Sell') */
    `side7`,
    /* Replace with a DOUBLE */
    `refPrc7`,
    /* Replace with a FLOAT */
    `refDelta7`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey8_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey8_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey8_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey8_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey8_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey8_dy`,
    /* Replace with a DOUBLE */
    `secKey8_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey8_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType8`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio8`,
    /* Replace with a ENUM('Buy','Sell') */
    `side8`,
    /* Replace with a DOUBLE */
    `refPrc8`,
    /* Replace with a FLOAT */
    `refDelta8`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey9_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey9_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey9_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey9_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey9_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey9_dy`,
    /* Replace with a DOUBLE */
    `secKey9_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey9_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType9`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio9`,
    /* Replace with a ENUM('Buy','Sell') */
    `side9`,
    /* Replace with a DOUBLE */
    `refPrc9`,
    /* Replace with a FLOAT */
    `refDelta9`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey10_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey10_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey10_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey10_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey10_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey10_dy`,
    /* Replace with a DOUBLE */
    `secKey10_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey10_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType10`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio10`,
    /* Replace with a ENUM('Buy','Sell') */
    `side10`,
    /* Replace with a DOUBLE */
    `refPrc10`,
    /* Replace with a FLOAT */
    `refDelta10`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey11_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey11_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey11_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey11_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey11_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey11_dy`,
    /* Replace with a DOUBLE */
    `secKey11_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey11_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType11`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio11`,
    /* Replace with a ENUM('Buy','Sell') */
    `side11`,
    /* Replace with a DOUBLE */
    `refPrc11`,
    /* Replace with a FLOAT */
    `refDelta11`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey12_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey12_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey12_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey12_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey12_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey12_dy`,
    /* Replace with a DOUBLE */
    `secKey12_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey12_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType12`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio12`,
    /* Replace with a ENUM('Buy','Sell') */
    `side12`,
    /* Replace with a DOUBLE */
    `refPrc12`,
    /* Replace with a FLOAT */
    `refDelta12`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey13_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey13_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey13_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey13_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey13_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey13_dy`,
    /* Replace with a DOUBLE */
    `secKey13_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey13_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType13`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio13`,
    /* Replace with a ENUM('Buy','Sell') */
    `side13`,
    /* Replace with a DOUBLE */
    `refPrc13`,
    /* Replace with a FLOAT */
    `refDelta13`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey14_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey14_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey14_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey14_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey14_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey14_dy`,
    /* Replace with a DOUBLE */
    `secKey14_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey14_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType14`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio14`,
    /* Replace with a ENUM('Buy','Sell') */
    `side14`,
    /* Replace with a DOUBLE */
    `refPrc14`,
    /* Replace with a FLOAT */
    `refDelta14`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey15_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey15_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey15_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey15_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey15_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey15_dy`,
    /* Replace with a DOUBLE */
    `secKey15_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey15_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType15`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio15`,
    /* Replace with a ENUM('Buy','Sell') */
    `side15`,
    /* Replace with a DOUBLE */
    `refPrc15`,
    /* Replace with a FLOAT */
    `refDelta15`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey16_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey16_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey16_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey16_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey16_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey16_dy`,
    /* Replace with a DOUBLE */
    `secKey16_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey16_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType16`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio16`,
    /* Replace with a ENUM('Buy','Sell') */
    `side16`,
    /* Replace with a DOUBLE */
    `refPrc16`,
    /* Replace with a FLOAT */
    `refDelta16`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey17_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey17_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey17_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey17_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey17_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey17_dy`,
    /* Replace with a DOUBLE */
    `secKey17_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey17_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType17`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio17`,
    /* Replace with a ENUM('Buy','Sell') */
    `side17`,
    /* Replace with a DOUBLE */
    `refPrc17`,
    /* Replace with a FLOAT */
    `refDelta17`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey18_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey18_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey18_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey18_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey18_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey18_dy`,
    /* Replace with a DOUBLE */
    `secKey18_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey18_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType18`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio18`,
    /* Replace with a ENUM('Buy','Sell') */
    `side18`,
    /* Replace with a DOUBLE */
    `refPrc18`,
    /* Replace with a FLOAT */
    `refDelta18`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey19_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey19_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey19_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey19_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey19_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey19_dy`,
    /* Replace with a DOUBLE */
    `secKey19_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey19_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType19`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio19`,
    /* Replace with a ENUM('Buy','Sell') */ 
    `side19`,
    /* Replace with a DOUBLE */
    `refPrc19`,
    /* Replace with a FLOAT */
    `refDelta19`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE') */
    `secKey20_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX') */
    `secKey20_ts`,
    /* Replace with a VARCHAR(12) */
    `secKey20_tk`,
    /* Replace with a SMALLINT UNSIGNED */
    `secKey20_yr`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey20_mn`,
    /* Replace with a TINYINT UNSIGNED */
    `secKey20_dy`,
    /* Replace with a DOUBLE */
    `secKey20_xx`,
    /* Replace with a ENUM('Call','Put','Pair') */
    `secKey20_cp`,
    /* Replace with a ENUM('None','Stock','Future','Option','MLeg') */
    `secType20`,
    /* Replace with a SMALLINT UNSIGNED */
    `ratio20`,
    /* Replace with a ENUM('Buy','Sell') */
    `side20`,
    /* Replace with a DOUBLE */
    `refPrc20`,
    /* Replace with a FLOAT */
    `refDelta20`,
    /* Replace with a DATETIME(6) */
    `timestamp`
) 
VALUES(
    1234567890,
    'None',
    'Example_accnt',
    'Example_clientFirm',
    'Example_altRequestId',
    'None',
    'None',
    'Example_secKey1_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey2_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey3_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey4_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey5_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey6_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey7_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey8_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey9_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey10_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey11_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey12_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey13_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey14_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey15_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey16_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey17_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey18_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey19_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    'None',
    'None',
    'Example_secKey20_tk',
    123,
    1,
    1,
    4.56,
    'Call',
    'None',
    123,
    'Buy',
    4.56,
    1.23,
    '2022-01-01 12:34:56.000000'
);

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='SecDefRequestGateway' ORDER BY ordinal_position ASC;